package com.anolesoft.yr.mbus.pre.sql;

public class PreOrderServiceOnlySQL {

    //新增报价单单一服务内容
    public static final String SAVE_PRE_ORDER_SERVICE_ONLY = "insert into pre_order_service_only(objuid,fac_code,pre_order_uid,pre_order_prod_uid,name,level,begin_time,end_time,offer_price,remark,c_user_uid,c_time,del_flag) values(#{objuid},#{facCode},#{preOrderUid},#{preOrderProdUid},#{name},#{level},#{beginTime},#{endTime},#{offerPrice},#{remark},#{ccUserUid},#{ccTime},#{delFlag})";

    //删除报价单服务
    public static final String DELETE_PRE_ORDER_SERVICE_ONLY = "update pre_order_service_only a set a.del_flag=1 where a.pre_order_uid=#{objuid}";

}
